﻿CREATE TABLE [dbo].[WXAlarm] (
    [Id]           INT             IDENTITY (1, 1) NOT NULL,
    [AppId]        NVARCHAR (50)   NULL,
    [ErrorType]    NVARCHAR (50)   NULL,
    [Description]  NVARCHAR (1000) NULL,
    [AlarmContent] NVARCHAR (1000) NULL,
    [TimeStamp]    NVARCHAR (50)   NULL,
    [AppSignature] NVARCHAR (50)   NULL,
    [SignMethod]   NVARCHAR (50)   NULL,
    [CreateDate]   DATETIME        NULL,
    [Solution]     NVARCHAR (500)  NULL,
    [DealDate]     DATETIME        NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'字段名称：公众号 id；字段来源：商户注册具有支付权限的公众号成功后即可获得；传入方式：由商户直接传入。', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'WXAlarm', @level2type = N'COLUMN', @level2name = N'AppId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'错误类型', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'WXAlarm', @level2type = N'COLUMN', @level2name = N'ErrorType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'错误描述', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'WXAlarm', @level2type = N'COLUMN', @level2name = N'Description';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'错误内容', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'WXAlarm', @level2type = N'COLUMN', @level2name = N'AlarmContent';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'字段名称：时间戳；字段来源：商户生成从 1970 年 1 月 1 日 00：00：00 至今的秒数，即当前的时间；由商户生成后传入。取值范围：32 字符以下', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'WXAlarm', @level2type = N'COLUMN', @level2name = N'TimeStamp';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'依然是根据前文 paySign 所述的签名方式生成，参不签名的字段为： appid、', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'WXAlarm', @level2type = N'COLUMN', @level2name = N'AppSignature';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'签名方式', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'WXAlarm', @level2type = N'COLUMN', @level2name = N'SignMethod';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'创建时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'WXAlarm', @level2type = N'COLUMN', @level2name = N'CreateDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'解决方案', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'WXAlarm', @level2type = N'COLUMN', @level2name = N'Solution';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'处理时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'WXAlarm', @level2type = N'COLUMN', @level2name = N'DealDate';

